﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using BAL.Entities;
using DAL.SQLStatements;

namespace DigitalAnts.App_Code.DAL.LogicComponents
{
    public class clsEmployeeLoginDAL
    {
        #region --- Emoloyee login
        public static bool queryEmployeeLogin(clsEmployee obj)
        {
            // Select all of products by user id
            clsQueryBuilder query = new clsQueryBuilder();
            query.propTable = "tblEmployee";
            query.propColumn = "*";
            query.propWhere = "colEmployeeID > 0 and colUserName = '" + obj.UserName + "' and colRole = '" + obj.Role + "'";

            // return result
            return query.getBoolValue();
        }
        #endregion ---
    }
}